400 |
Can I change the format of date to be shown in the control
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); var_Columns->Add(L"Default"); EXLISTLib::IColumnPtr var_Column = ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Format.1"))); var_Column->PutComputedField(L"%0"); var_Column->PutFormatColumn(L"dateF(value) replace `/` with `-`"); EXLISTLib::IColumnPtr var_Column1 = ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Format.2"))); var_Column1->PutComputedField(L"%0"); var_Column1->PutDef(EXLISTLib::exCaptionFormat,long(1)); var_Column1->PutFormatColumn(L"`<b>`+ shortdate(value) + `</b> ` + timeF(value)"); EXLISTLib::IColumnPtr var_Column2 = ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Format.3"))); var_Column2->PutComputedField(L"%0"); var_Column2->PutDef(EXLISTLib::exCaptionFormat,long(1)); var_Column2->PutFormatColumn(_bstr_t("( dateF(value) replace `/` with `-` ) + ` <b>`+ ( weekday(value) case ( 0 : `Su`; 1 : `Mo`; 2 : `Tu`; 3 : `We`; 4 : `Th`; 5 : `") + "Fr`; 6 : `Sa`) )"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add(COleDateTime(2001,1,1,10,00,00).operator DATE()); var_Items->Add(COleDateTime(2001,1,2,10,00,00).operator DATE()); |
399 |
How can I put a picture on the cell's background (method 3)
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetVisualAppearance()->Add(1,"c:\\exontrol\\images\\normal.ebn"); spList1->GetVisualAppearance()->Add(2,"CP:1 0 0 -164 0"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); var_Columns->Add(L"column"); EXLISTLib::IColumnPtr var_Column = ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"column"))); var_Column->PutAlignment(EXLISTLib::CenterAlignment); var_Column->PutHeaderAlignment(EXLISTLib::CenterAlignment); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long i = var_Items->Add(vtMissing); var_Items->PutSelectableItem(i,VARIANT_FALSE); var_Items->PutCaption(i,long(1),"caption"); var_Items->PutCellBackColor(i,long(1),0x2000000); |
398 |
How can I put a picture on the cell's background (method 2)
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetVisualAppearance()->Add(1,"c:\\exontrol\\images\\normal.ebn"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); var_Columns->Add(L"column"); var_Columns->Add(L"column"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long i = var_Items->Add(vtMissing); var_Items->PutSelectableItem(i,VARIANT_FALSE); var_Items->PutCaption(i,long(1),"caption"); var_Items->PutCellBackColor(i,long(1),0x1000000); var_Items->PutCellPicture(i,long(1),((IDispatch*)(spList1->ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\auction.gif`)")))); var_Items->PutCellPictureWidth(i,long(1),128); var_Items->PutCellPictureHeight(i,long(1),spList1->GetDefaultItemHeight()); |
397 |
How can I put a picture on the cell's background (method 1)
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetVisualAppearance()->Add(1,"c:\\exontrol\\images\\normal.ebn"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); var_Columns->Add(L"column"); EXLISTLib::IColumnPtr var_Column = ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"column"))); var_Column->PutAlignment(EXLISTLib::CenterAlignment); var_Column->PutHeaderAlignment(EXLISTLib::CenterAlignment); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long i = var_Items->Add(vtMissing); var_Items->PutSelectableItem(i,VARIANT_FALSE); var_Items->PutCaption(i,long(1),"caption"); var_Items->PutCellBackColor(i,long(1),0x1000000); |
396 |
How do I access the cells, or how do I get the values in the columns
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); var_Columns->Add(L"C1"); var_Columns->Add(L"C2"); var_Columns->Add(L"C3"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h = var_Items->Add("Item 1"); var_Items->PutCaption(h,long(1),"SubItem 1.1"); var_Items->PutCaption(h,long(2),"SubItem 1.2"); OutputDebugStringW( _bstr_t(var_Items->GetCaption(h,long(2))) ); |
395 |
How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); EXLISTLib::IConditionalFormatPtr var_ConditionalFormat = spList1->GetConditionalFormats()->Add(L"1","K1"); var_ConditionalFormat->PutBackColor(RGB(255,0,0)); var_ConditionalFormat->PutApplyTo(EXLISTLib::FormatApplyToEnum(0x1)); EXLISTLib::IConditionalFormatPtr var_ConditionalFormat1 = spList1->GetConditionalFormats()->Add(L"1","K2"); var_ConditionalFormat1->PutBackColor(RGB(255,0,0)); var_ConditionalFormat1->PutApplyTo(EXLISTLib::FormatApplyToEnum(0x2)); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutDrawGridLines(EXLISTLib::GridLinesEnum(0xfffffffc | EXLISTLib::exVLines)); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); var_Columns->Add(L"Column 1"); var_Columns->Add(L"Column 2"); var_Columns->Add(L"Column 3"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add(vtMissing); var_Items->Add(vtMissing); var_Items->Add(vtMissing); spList1->EndUpdate(); |
394 |
How can I get the list of items as they are displayed
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutBackColorAlternate(RGB(240,240,240)); spList1->GetColumns()->Add(L"Names"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add("Mantel"); var_Items->Add("Mechanik"); var_Items->Add("Motor"); var_Items->Add("Murks"); var_Items->Add("Märchen"); var_Items->Add("Möhren"); var_Items->Add("Mühle"); spList1->GetColumns()->GetItem(long(0))->PutSortOrder(EXLISTLib::SortAscending); spList1->EndUpdate(); OutputDebugStringW( _bstr_t(spList1->GetItems(long(1))) ); |
393 |
Is posible to reduce the size of the picture to be shown in the column's caption
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutHTMLPicture(L"pic1","c:\\exontrol\\images\\zipdisk.gif"); spList1->PutHeaderHeight(48); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"DefaultSize")))->PutHTMLCaption(L"Default-Size <img>pic1</img> Picture"); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"CustomSize")))->PutHTMLCaption(L"Custom-Size <img>pic1:16</img> Picture"); spList1->EndUpdate(); |
392 |
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutMarkSearchColumn(VARIANT_FALSE); EXLISTLib::IConditionalFormatPtr var_ConditionalFormat = spList1->GetConditionalFormats()->Add(L"1",vtMissing); var_ConditionalFormat->PutBold(VARIANT_TRUE); var_ConditionalFormat->PutForeColor(RGB(255,0,0)); var_ConditionalFormat->PutApplyTo(EXLISTLib::FormatApplyToEnum(0x1)); spList1->GetColumns()->Add(L"C1"); EXLISTLib::IColumnPtr var_Column = ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"C2"))); var_Column->PutHeaderBold(VARIANT_TRUE); var_Column->PutHTMLCaption(L"<fgcolor=FF0000>C2"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->PutCaption(var_Items->Add(long(10)),long(1),long(11)); var_Items->PutCaption(var_Items->Add(long(12)),long(1),long(13)); spList1->EndUpdate(); |
391 |
Is it possible to limit the height of item while resizing the row
// AddItem event - Occurs after a new Item is inserted to Items collection. void OnAddItemList1(long Item) { /* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetItems()->PutItemMinHeight(Item,18); spList1->GetItems()->PutItemMaxHeight(Item,72); } EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutItemsAllowSizing(EXLISTLib::exResizeItem); spList1->PutScrollBySingleLine(VARIANT_FALSE); spList1->PutBackColorAlternate(RGB(240,240,240)); spList1->GetColumns()->Add(L"Names"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add("Mantel"); var_Items->Add("Mechanik"); var_Items->Add("Motor"); var_Items->Add("Murks"); var_Items->Add("Märchen"); var_Items->Add("Möhren"); var_Items->Add("Mühle"); spList1->GetColumns()->GetItem(long(0))->PutSortOrder(EXLISTLib::SortAscending); spList1->EndUpdate(); |
390 |
Can I specify un-sortable items so they keep their position once the user sorts the columns
|
389 |
The item is not getting selected when clicking the cell's checkbox. What should I do
|
388 |
Does your control supports multiple lines tooltip
|
387 |
How can I prevent highlighting the column from the cursor - point
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetVisualAppearance()->Add(1,_bstr_t("gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZLhEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJ") + "gEgI="); spList1->PutBackground(EXLISTLib::exCursorHoverColumn,0x1000000); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"S")))->PutWidth(32); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"Level 1")))->PutLevelKey(long(1)); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"Level 2")))->PutLevelKey(long(1)); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"Level 3")))->PutLevelKey(long(1)); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"E1")))->PutWidth(32); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"E2")))->PutWidth(32); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"E3")))->PutWidth(32); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"E4")))->PutWidth(32); |
386 |
Is there any option to show the tooltip programmatically
|
385 |
Is it possible to prevent covering the colors by selected rows
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->PutSelBackMode(EXLISTLib::exTransparent); spList1->PutBackColorAlternate(RGB(240,240,240)); spList1->GetColumns()->Add(L"Column"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add("Item 1"); var_Items->Add("Item 2"); var_Items->Add("Item 3"); var_Items->Add("Item 4"); var_Items->Add("Item 5"); |
384 |
Can I use PNG images to display pictures in the control
|
383 |
Does your control support conditional format and computed fields
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutMarkSearchColumn(VARIANT_FALSE); EXLISTLib::IConditionalFormatsPtr var_ConditionalFormats = spList1->GetConditionalFormats(); EXLISTLib::IConditionalFormatPtr var_ConditionalFormat = var_ConditionalFormats->Add(L"%1 >4",vtMissing); var_ConditionalFormat->PutBold(VARIANT_TRUE); var_ConditionalFormat->PutStrikeOut(VARIANT_TRUE); var_ConditionalFormat->PutForeColor(RGB(255,0,0)); var_ConditionalFormat->PutApplyTo(EXLISTLib::FormatApplyToEnum(0x1)); EXLISTLib::IConditionalFormatPtr var_ConditionalFormat1 = var_ConditionalFormats->Add(L"%2 > 4",vtMissing); var_ConditionalFormat1->PutBold(VARIANT_TRUE); var_ConditionalFormat1->PutStrikeOut(VARIANT_TRUE); var_ConditionalFormat1->PutForeColor(RGB(255,0,0)); var_ConditionalFormat1->PutApplyTo(EXLISTLib::FormatApplyToEnum(0x2)); EXLISTLib::IConditionalFormatPtr var_ConditionalFormat2 = var_ConditionalFormats->Add(L"%3 > 4",vtMissing); var_ConditionalFormat2->PutBold(VARIANT_TRUE); var_ConditionalFormat2->PutStrikeOut(VARIANT_TRUE); var_ConditionalFormat2->PutForeColor(RGB(255,0,0)); var_ConditionalFormat2->PutApplyTo(EXLISTLib::FormatApplyToEnum(0x3)); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); var_Columns->Add(L"Name"); EXLISTLib::IColumnPtr var_Column = ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"A"))); var_Column->PutSortType(EXLISTLib::SortNumeric); var_Column->PutAllowSizing(VARIANT_FALSE); var_Column->PutWidth(36); var_Column->PutFormatColumn(L"len(value) ? value + ' +'"); EXLISTLib::IColumnPtr var_Column1 = ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"B"))); var_Column1->PutSortType(EXLISTLib::SortNumeric); var_Column1->PutAllowSizing(VARIANT_FALSE); var_Column1->PutWidth(36); var_Column1->PutFormatColumn(L"len(value) ? value + ' +'"); EXLISTLib::IColumnPtr var_Column2 = ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"C"))); var_Column2->PutSortType(EXLISTLib::SortNumeric); var_Column2->PutAllowSizing(VARIANT_FALSE); var_Column2->PutWidth(36); var_Column2->PutFormatColumn(L"len(value) ? value + ' ='"); EXLISTLib::IColumnPtr var_Column3 = ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"A+B+C"))); var_Column3->PutSortType(EXLISTLib::SortNumeric); var_Column3->PutAllowSizing(VARIANT_FALSE); var_Column3->PutWidth(64); var_Column3->PutComputedField(L"%1+%2+%3"); var_Column3->PutFormatColumn(L"((0:=dbl(value)) < 10? '<fgcolor=808080><font ;7>' :'<b>') + currency(=:0)"); var_Column3->PutDef(EXLISTLib::exCaptionFormat,long(1)); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h1 = var_Items->Add("Item 1"); var_Items->PutCaption(h1,long(1),long(7)); var_Items->PutCaption(h1,long(2),long(3)); var_Items->PutCaption(h1,long(3),long(1)); h1 = var_Items->Add("Item 2"); var_Items->PutCaption(h1,long(1),long(2)); var_Items->PutCaption(h1,long(2),long(5)); var_Items->PutCaption(h1,long(3),long(12)); h1 = var_Items->Add("Item 3"); var_Items->PutCaption(h1,long(1),long(2)); var_Items->PutCaption(h1,long(2),long(2)); var_Items->PutCaption(h1,long(3),long(4)); h1 = var_Items->Add("Item 4"); var_Items->PutCaption(h1,long(1),long(2)); var_Items->PutCaption(h1,long(2),long(9)); var_Items->PutCaption(h1,long(3),long(4)); spList1->EndUpdate(); |
382 |
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
|
381 |
Can I display the cell's check box after the text
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); EXLISTLib::IColumnPtr var_Column = ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"Column"))); var_Column->PutDef(EXLISTLib::exCellHasCheckBox,VARIANT_TRUE); var_Column->PutDef(EXLISTLib::exCellDrawPartsOrder,"caption,check"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->PutCellHasCheckBox(var_Items->Add("Caption 1"),long(0),VARIANT_TRUE); var_Items->PutCellHasCheckBox(var_Items->Add("Caption 2"),long(0),VARIANT_TRUE); |
380 |
Can I change the order of the parts in the cell, as checkbox after the text, and so on
|
379 |
Can I have an image displayed after the text. Can I get that effect without using HTML content
|
378 |
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
|
377 |
How can I change the foreground color for a particular column
|
376 |
How can I change the background color for a particular column
|
375 |
How can I display the column using currency format and enlarge the font for certain values
|
374 |
How can I highlight only parts of the cells
|
373 |
How can I get the number of occurrences of a specified string in the cell
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetColumns()->Add(L""); EXLISTLib::IColumnPtr var_Column = ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"occurrences"))); var_Column->PutComputedField(L"lower(%0) count 'o'"); var_Column->PutFormatColumn(L"'contains ' + value + ' of \\'o\\' chars'"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h = var_Items->Add("Root"); var_Items->Add("Child 1 oooof the root"); var_Items->Add("Child 2"); var_Items->Add("Child 3"); |
372 |
How can I display dates in my format
|
371 |
How can I display dates in short format
|
370 |
How can I display dates in long format
|
369 |
How can I display only the right part of the cell
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetColumns()->Add(L""); EXLISTLib::IColumnPtr var_Column = ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"Right"))); var_Column->PutComputedField(L"%0 right 2"); var_Column->PutFormatColumn(L"'\"' + value + '\"'"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h = var_Items->Add("Root"); var_Items->Add("Child 1"); var_Items->Add("Child 2"); var_Items->Add("SChild 3"); |
368 |
How can I display only the left part of the cell
|
367 |
How can I display true or false instead 0 and -1
|
366 |
How can I display icons or images instead numbers
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->Images(_bstr_t("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXLISTLib::IColumnPtr var_Column = ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"Icons"))); var_Column->PutDef(EXLISTLib::exCaptionFormat,long(1)); var_Column->PutFormatColumn(L"'The cell displays the icon <img>'+value+'</img> instead ' + value"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add(long(1)); var_Items->Add(long(2)); var_Items->Add(long(3)); |
365 |
How can I display the column using currency
|
364 |
Is is possible to use HTML tags to display in the filter caption
|
363 |
How can I find the number of items after filtering
|
362 |
How can I change the filter caption
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPromptType(EXLISTLib::FilterPromptEnum(EXLISTLib::exFilterPromptWords | EXLISTLib::exFilterPromptContainsAll)); spList1->PutFilterBarPromptPattern(L"london robert"); spList1->PutFilterBarCaption(L"<r>Found: ... "); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h0 = var_Items->Add("Nancy Davolio"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Andrew Fuller"); var_Items->PutCaption(h0,long(1),"Vice President, Sales"); var_Items->PutCaption(h0,long(2),"Tacoma"); var_Items->PutSelectItem(h0,VARIANT_TRUE); h0 = var_Items->Add("Janet Leverling"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Kirkland"); h0 = var_Items->Add("Margaret Peacock"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Redmond"); h0 = var_Items->Add("Steven Buchanan"); var_Items->PutCaption(h0,long(1),"Sales Manager"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Michael Suyama"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Robert King"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Laura Callahan"); var_Items->PutCaption(h0,long(1),"Inside Sales Coordinator"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Anne Dodsworth"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); spList1->EndUpdate(); |
361 |
While using the filter prompt is it is possible to use wild characters
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPromptType(EXLISTLib::exFilterPromptPattern); spList1->PutFilterBarPromptPattern(L"lon* seat*"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h0 = var_Items->Add("Nancy Davolio"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Andrew Fuller"); var_Items->PutCaption(h0,long(1),"Vice President, Sales"); var_Items->PutCaption(h0,long(2),"Tacoma"); var_Items->PutSelectItem(h0,VARIANT_TRUE); h0 = var_Items->Add("Janet Leverling"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Kirkland"); h0 = var_Items->Add("Margaret Peacock"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Redmond"); h0 = var_Items->Add("Steven Buchanan"); var_Items->PutCaption(h0,long(1),"Sales Manager"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Michael Suyama"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Robert King"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Laura Callahan"); var_Items->PutCaption(h0,long(1),"Inside Sales Coordinator"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Anne Dodsworth"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); spList1->EndUpdate(); |
360 |
How can I list all items that contains any of specified words, not necessary at the beggining
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPromptType(EXLISTLib::FilterPromptEnum(EXLISTLib::exFilterPromptStartWords | EXLISTLib::exFilterPromptContainsAny)); spList1->PutFilterBarPromptPattern(L"london davolio"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h0 = var_Items->Add("Nancy Davolio"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Andrew Fuller"); var_Items->PutCaption(h0,long(1),"Vice President, Sales"); var_Items->PutCaption(h0,long(2),"Tacoma"); var_Items->PutSelectItem(h0,VARIANT_TRUE); h0 = var_Items->Add("Janet Leverling"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Kirkland"); h0 = var_Items->Add("Margaret Peacock"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Redmond"); h0 = var_Items->Add("Steven Buchanan"); var_Items->PutCaption(h0,long(1),"Sales Manager"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Michael Suyama"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Robert King"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Laura Callahan"); var_Items->PutCaption(h0,long(1),"Inside Sales Coordinator"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Anne Dodsworth"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); spList1->EndUpdate(); |
359 |
How can I list all items that contains any of specified words, not strings
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPromptType(EXLISTLib::FilterPromptEnum(EXLISTLib::exFilterPromptWords | EXLISTLib::exFilterPromptContainsAny)); spList1->PutFilterBarPromptPattern(L"london nancy"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h0 = var_Items->Add("Nancy Davolio"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Andrew Fuller"); var_Items->PutCaption(h0,long(1),"Vice President, Sales"); var_Items->PutCaption(h0,long(2),"Tacoma"); var_Items->PutSelectItem(h0,VARIANT_TRUE); h0 = var_Items->Add("Janet Leverling"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Kirkland"); h0 = var_Items->Add("Margaret Peacock"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Redmond"); h0 = var_Items->Add("Steven Buchanan"); var_Items->PutCaption(h0,long(1),"Sales Manager"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Michael Suyama"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Robert King"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Laura Callahan"); var_Items->PutCaption(h0,long(1),"Inside Sales Coordinator"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Anne Dodsworth"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); spList1->EndUpdate(); |
358 |
How can I list all items that contains all specified words, not strings
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPromptType(EXLISTLib::FilterPromptEnum(EXLISTLib::exFilterPromptWords | EXLISTLib::exFilterPromptContainsAll)); spList1->PutFilterBarPromptPattern(L"london robert"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h0 = var_Items->Add("Nancy Davolio"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Andrew Fuller"); var_Items->PutCaption(h0,long(1),"Vice President, Sales"); var_Items->PutCaption(h0,long(2),"Tacoma"); var_Items->PutSelectItem(h0,VARIANT_TRUE); h0 = var_Items->Add("Janet Leverling"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Kirkland"); h0 = var_Items->Add("Margaret Peacock"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Redmond"); h0 = var_Items->Add("Steven Buchanan"); var_Items->PutCaption(h0,long(1),"Sales Manager"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Michael Suyama"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Robert King"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Laura Callahan"); var_Items->PutCaption(h0,long(1),"Inside Sales Coordinator"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Anne Dodsworth"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); spList1->EndUpdate(); |
357 |
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPromptType(EXLISTLib::FilterPromptEnum(EXLISTLib::exFilterPromptCaseSensitive | EXLISTLib::exFilterPromptContainsAny)); spList1->PutFilterBarPromptPattern(L"Anne"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h0 = var_Items->Add("Nancy Davolio"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Andrew Fuller"); var_Items->PutCaption(h0,long(1),"Vice President, Sales"); var_Items->PutCaption(h0,long(2),"Tacoma"); var_Items->PutSelectItem(h0,VARIANT_TRUE); h0 = var_Items->Add("Janet Leverling"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Kirkland"); h0 = var_Items->Add("Margaret Peacock"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Redmond"); h0 = var_Items->Add("Steven Buchanan"); var_Items->PutCaption(h0,long(1),"Sales Manager"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Michael Suyama"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Robert King"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Laura Callahan"); var_Items->PutCaption(h0,long(1),"Inside Sales Coordinator"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Anne Dodsworth"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); spList1->EndUpdate(); |
356 |
Is it possible to list only items that ends with any of specified strings
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPromptType(EXLISTLib::exFilterPromptEndWith); spList1->PutFilterBarPromptColumns("0"); spList1->PutFilterBarPromptPattern(L"Fuller"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h0 = var_Items->Add("Nancy Davolio"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Andrew Fuller"); var_Items->PutCaption(h0,long(1),"Vice President, Sales"); var_Items->PutCaption(h0,long(2),"Tacoma"); var_Items->PutSelectItem(h0,VARIANT_TRUE); h0 = var_Items->Add("Janet Leverling"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Kirkland"); h0 = var_Items->Add("Margaret Peacock"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Redmond"); h0 = var_Items->Add("Steven Buchanan"); var_Items->PutCaption(h0,long(1),"Sales Manager"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Michael Suyama"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Robert King"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Laura Callahan"); var_Items->PutCaption(h0,long(1),"Inside Sales Coordinator"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Anne Dodsworth"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); spList1->EndUpdate(); |
355 |
Is it possible to list only items that ends with any of specified strings
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPromptType(EXLISTLib::exFilterPromptEndWith); spList1->PutFilterBarPromptColumns("0"); spList1->PutFilterBarPromptPattern(L"Fuller"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h0 = var_Items->Add("Nancy Davolio"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Andrew Fuller"); var_Items->PutCaption(h0,long(1),"Vice President, Sales"); var_Items->PutCaption(h0,long(2),"Tacoma"); var_Items->PutSelectItem(h0,VARIANT_TRUE); h0 = var_Items->Add("Janet Leverling"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Kirkland"); h0 = var_Items->Add("Margaret Peacock"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Redmond"); h0 = var_Items->Add("Steven Buchanan"); var_Items->PutCaption(h0,long(1),"Sales Manager"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Michael Suyama"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Robert King"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Laura Callahan"); var_Items->PutCaption(h0,long(1),"Inside Sales Coordinator"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Anne Dodsworth"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); spList1->EndUpdate(); |
354 |
Is it possible to list only items that starts with any of specified strings
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPromptType(EXLISTLib::exFilterPromptStartWith); spList1->PutFilterBarPromptColumns("0"); spList1->PutFilterBarPromptPattern(L"An M"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h0 = var_Items->Add("Nancy Davolio"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Andrew Fuller"); var_Items->PutCaption(h0,long(1),"Vice President, Sales"); var_Items->PutCaption(h0,long(2),"Tacoma"); var_Items->PutSelectItem(h0,VARIANT_TRUE); h0 = var_Items->Add("Janet Leverling"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Kirkland"); h0 = var_Items->Add("Margaret Peacock"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Redmond"); h0 = var_Items->Add("Steven Buchanan"); var_Items->PutCaption(h0,long(1),"Sales Manager"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Michael Suyama"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Robert King"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Laura Callahan"); var_Items->PutCaption(h0,long(1),"Inside Sales Coordinator"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Anne Dodsworth"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); spList1->EndUpdate(); |
353 |
Is it possible to list only items that starts with specified string
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPromptType(EXLISTLib::exFilterPromptStartWith); spList1->PutFilterBarPromptColumns("0"); spList1->PutFilterBarPromptPattern(L"A"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h0 = var_Items->Add("Nancy Davolio"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Andrew Fuller"); var_Items->PutCaption(h0,long(1),"Vice President, Sales"); var_Items->PutCaption(h0,long(2),"Tacoma"); var_Items->PutSelectItem(h0,VARIANT_TRUE); h0 = var_Items->Add("Janet Leverling"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Kirkland"); h0 = var_Items->Add("Margaret Peacock"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"Redmond"); h0 = var_Items->Add("Steven Buchanan"); var_Items->PutCaption(h0,long(1),"Sales Manager"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Michael Suyama"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Robert King"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); h0 = var_Items->Add("Laura Callahan"); var_Items->PutCaption(h0,long(1),"Inside Sales Coordinator"); var_Items->PutCaption(h0,long(2),"Seattle"); h0 = var_Items->Add("Anne Dodsworth"); var_Items->PutCaption(h0,long(1),"Sales Representative"); var_Items->PutCaption(h0,long(2),"London"); spList1->EndUpdate(); |
352 |
How can I specify that the list should include any of the seqeunces in the pattern
|
351 |
How can I specify that all sequences in the filter pattern must be included in the list
|
350 |
How do I change at runtime the filter prompt
|
349 |
How do I specify to filter only a single column when using the filter prompt
|
348 |
How do I change the prompt or the caption being displayed in the filter bar
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutColumnAutoResize(VARIANT_TRUE); spList1->PutContinueColumnScroll(VARIANT_FALSE); spList1->PutMarkSearchColumn(VARIANT_FALSE); spList1->PutSearchColumnIndex(1); spList1->PutFilterBarPromptVisible(VARIANT_TRUE); spList1->PutFilterBarPrompt(L"changed"); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Name")))->PutWidth(96); ((EXLISTLib::IColumnPtr)(var_Columns->Add(L"Title")))->PutWidth(96); var_Columns->Add(L"City"); spList1->EndUpdate(); |
347 |
How do I enable the filter prompt feature
|
346 |
Is it possible to change the style for the vertical or horizontal grid lines, in the list area
|
345 |
Is it possible to change the style for the grid lines, for instance to be solid not dotted
|
344 |
How can I filter programatically using more columns
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->PutMarkSearchColumn(VARIANT_FALSE); EXLISTLib::IColumnsPtr var_Columns = spList1->GetColumns(); var_Columns->Add(L"Car"); var_Columns->Add(L"Equipment"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->PutCaption(var_Items->Add("Mazda"),long(1),"Air Bag"); var_Items->PutCaption(var_Items->Add("Toyota"),long(1),"Air Bag,Air condition"); var_Items->PutCaption(var_Items->Add("Ford"),long(1),"Air condition"); var_Items->PutCaption(var_Items->Add("Nissan"),long(1),"Air Bag,ABS,ESP"); var_Items->PutCaption(var_Items->Add("Mazda"),long(1),"Air Bag, ABS,ESP"); var_Items->PutCaption(var_Items->Add("Mazda"),long(1),"ABS,ESP"); EXLISTLib::IColumnPtr var_Column = spList1->GetColumns()->GetItem("Car"); var_Column->PutFilterType(EXLISTLib::exFilter); var_Column->PutFilter(L"Mazda"); EXLISTLib::IColumnPtr var_Column1 = spList1->GetColumns()->GetItem("Equipment"); var_Column1->PutFilterType(EXLISTLib::exPattern); var_Column1->PutFilter(L"*ABS*|*ESP*"); spList1->ApplyFilter(); spList1->EndUpdate(); |
343 |
How do I find an item based on my extra data
|
342 |
How do I print the control's content
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->BeginUpdate(); spList1->GetColumns()->Add(L"Number"); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"Currency")))->PutComputedField(L"len(%0) ? currency(dbl(%0)) : ''"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add("1.23"); var_Items->Add("2.34"); var_Items->Add("0"); var_Items->PutItemBackColor(var_Items->Add(vtMissing),RGB(255,128,128)); var_Items->Add("10000.99"); spList1->EndUpdate(); /* Includes the definition for CreateObject function like follows: #include <comdef.h> IUnknownPtr CreateObject( BSTR Object ) { IUnknownPtr spResult; spResult.CreateInstance( Object ); return spResult; }; */ /* Copy and paste the following directives to your header file as it defines the namespace 'EXPRINTLib' for the library: 'ExPrint 1.0 Control Library' #import <ExPrint.dll> using namespace EXPRINTLib; */ EXPRINTLib::IExPrintPtr var_Print = ::CreateObject(L"Exontrol.Print"); var_Print->PutPrintExt(((EXLISTLib::IListPtr)(spList1))); var_Print->Preview(); |
341 |
How can I display the currency only for not empty cells
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetColumns()->Add(L"Number"); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"Currency")))->PutComputedField(L"len(%0) ? currency(dbl(%0)) : ''"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add("1.23"); var_Items->Add("2.34"); var_Items->Add("0"); var_Items->PutItemBackColor(var_Items->Add(vtMissing),RGB(255,128,128)); var_Items->Add("10000.99"); |
340 |
Is there a function to display the number of days between two date including the number of hours
|
339 |
Is there a function to display the number of days between two date including the number of hours
|
338 |
How can I display the number of days between two dates
|
337 |
How can I get second part of the date
|
336 |
How can I get minute part of the date
|
335 |
How can I check the hour part only so I know it was afternoon
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetConditionalFormats()->Add(L"hour(%0)>=12",vtMissing)->PutBold(VARIANT_TRUE); spList1->GetColumns()->Add(L"Date"); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"Hour")))->PutComputedField(L"hour(%0)"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add(COleDateTime(2001,1,11,10,00,00).operator DATE()); var_Items->Add(COleDateTime(2002,2,22,11,00,00).operator DATE()); var_Items->Add(COleDateTime(2003,3,13,12,00,00).operator DATE()); var_Items->Add(COleDateTime(2004,4,14,13,00,00).operator DATE()); |
334 |
What about a function to get the day in the week, or days since Sunday
|
333 |
Is there any function to get the day of the year or number of days since January 1st
|
332 |
How can I display only the day of the date
|
331 |
How can I display only the month of the date
|
330 |
How can I get only the year part from a date expression
|
329 |
Can I convert the expression to date
|
328 |
Can I convert the expression to a number, double or float
|
327 |
How can I display dates in long format
|
326 |
How can I display dates in short format
|
325 |
How can I display the time only of a date expression
|
324 |
Is there any function to display currencies, or money formatted as in the control panel
|
323 |
How can I convert the expression to a string so I can look into the date string expression for month's name
|
322 |
Can I display the absolute value or positive part of the number
|
321 |
Is there any function to get largest number with no fraction part that is not greater than the value
|
320 |
Is there any function to round the values base on the .5 value
|
319 |
How can I get or display the integer part of the cell
|
318 |
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
|
317 |
Is there any option to display cells in uppercase
|
316 |
Is there any option to display cells in lowercase
|
315 |
How can I mark the cells that has a specified type, ie strings only
|
314 |
How can I bold the items that contains data or those who displays empty strings
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetConditionalFormats()->Add(L"not len(%1)=0",vtMissing)->PutBold(VARIANT_TRUE); spList1->GetColumns()->Add(L"C1"); spList1->GetColumns()->Add(L"C2"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); long h = var_Items->Add("Item 1"); var_Items->Add("Item 2"); long hC = var_Items->Add("Item 3"); var_Items->PutCaption(hC,long(1),"1"); var_Items->Add("Item 3"); |
313 |
Can I change the background color for items or cells that contains a specified string
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetConditionalFormats()->Add(L"%0 contains 'hi'",vtMissing)->PutBackColor(RGB(255,0,0)); spList1->GetColumns()->Add(L""); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add("Item 1"); var_Items->Add("Item 2"); var_Items->Add("Item 3"); var_Items->Add("Item 4 - child"); |
312 |
Is there any option to change the fore color for cells or items that ends with a specified string
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetConditionalFormats()->Add(L"%0 endwith '22'",vtMissing)->PutForeColor(RGB(255,0,0)); spList1->GetColumns()->Add(L""); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add("Item 1"); var_Items->Add("Item 2"); var_Items->Add("Item 1.22"); var_Items->Add("Item 2.22"); |
311 |
How can I highlight the cells or items that starts with a specified string
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetConditionalFormats()->Add(L"%0 startwith 'C'",vtMissing)->PutUnderline(VARIANT_TRUE); spList1->GetColumns()->Add(L""); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add("Item 1"); var_Items->Add("CItem 2"); var_Items->Add("Item 3"); var_Items->Add("Item 4"); |
310 |
How can I change the foreground color for a particular column
|
309 |
How can I change the background color for a particular column
|
308 |
How can I display the column's header using multiple lines
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->PutHeaderHeight(128); spList1->PutHeaderSingleLine(VARIANT_FALSE); ((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"This is just a column that should break the header.")))->PutWidth(32); spList1->GetColumns()->Add(L"This is just another column that should break the header."); |
307 |
How can I align the text/caption on the scroll bar
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->PutScrollPartCaption(EXLISTLib::exHScroll,EXLISTLib::exLowerBackPart,L"left"); spList1->PutScrollPartCaptionAlignment(EXLISTLib::exHScroll,EXLISTLib::exLowerBackPart,EXLISTLib::LeftAlignment); spList1->PutScrollPartCaption(EXLISTLib::exHScroll,EXLISTLib::exUpperBackPart,L"right"); spList1->PutScrollPartCaptionAlignment(EXLISTLib::exHScroll,EXLISTLib::exUpperBackPart,EXLISTLib::RightAlignment); spList1->PutColumnAutoResize(VARIANT_FALSE); spList1->GetColumns()->Add(L"1"); spList1->GetColumns()->Add(L"2"); spList1->GetColumns()->Add(L"3"); spList1->GetColumns()->Add(L"4"); spList1->GetColumns()->Add(L"5"); spList1->GetColumns()->Add(L"6"); |
306 |
How do I select the next row/item
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetColumns()->Add(L"Column"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->Add("Item 1"); var_Items->Add("Item 2"); var_Items->Add("Item 3"); var_Items->PutSelectItem(var_Items->GetNextVisibleItem(var_Items->GetFocusItem()),VARIANT_TRUE); |
305 |
How do I enable resizing ( changing the height ) the items at runtime
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->PutItemsAllowSizing(EXLISTLib::exResizeItem); spList1->PutDrawGridLines(EXLISTLib::exHLines); spList1->PutScrollBySingleLine(VARIANT_TRUE); spList1->GetColumns()->Add(L"Column"); spList1->GetItems()->Add("Item 1"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->PutItemHeight(var_Items->Add("Item 2"),48); spList1->GetItems()->Add("Item 3"); spList1->GetItems()->Add("Item 4"); |
304 |
How do I enable resizing all the items at runtime
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->PutItemsAllowSizing(EXLISTLib::exResizeAllItems); spList1->PutDrawGridLines(EXLISTLib::exHLines); spList1->GetColumns()->Add(L"Column"); spList1->GetItems()->Add("Item 1"); EXLISTLib::IItemsPtr var_Items = spList1->GetItems(); var_Items->PutItemHeight(var_Items->Add("Item 2"),48); spList1->GetItems()->Add("Item 3"); |
303 |
How can I remove the filter
|
302 |
How do I change the control's border, using your EBN files
/* Copy and paste the following directives to your header file as it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library' #import <ExList.dll> using namespace EXLISTLib; */ EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown(); spList1->GetVisualAppearance()->Add(1,"c:\\exontrol\\images\\normal.ebn"); spList1->PutAppearance(EXLISTLib::AppearanceEnum(0x1000000)); |
301 |
Can I change the style for break or divider line
|